Scenario 1 - Appending / concatenating data

The "Data" folder contains 12 monthly sales data files (CSV's)
Selecting them all and dragging-and-dropping them in to EasyMorph will automatically append them together. 

If we wish to append multiple sheets within the same Excel spreadsheet, we can select them in the "Import Excel spreadsheet" action settings and again they will automatically be appended together.

Note that we can also use the "Append another table" action to force 2 tables to append. Such as if we want to take a logs table and merge it will a logs_archive table.

We can see we have "Total" and "Total Price" columns and scrolling down shows we have most data in Total but September's data is in Total Price. We can also use the table meta data to see there are empty values. 

We could resolve this in the source file but lets fix in EasyMorph so that when we run the workflow again with new files the same problem will automatically be fixed.

Add the "Modify column(s)" action and use the expression generator "If the [Total] is empty use the [Total Price] else use [Total]"

We can now remove the "Total Price" column using "Keep/Remove column" action.